/****** Object:  Table [dbo].[lzfy_refund_master]    Script Date: 2025/6/19 12:37:00 ******/
USE [refunddb]
GO

/****** Object:  Table [dbo].[lzfy_refund_master]    Script Date: 2025/7/1 21:31:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lzfy_refund_master](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[input_date] [datetime] NULL,
	[patient_id] [varchar](50) NULL,
	[pat_name] [varchar](50) NULL,
	[id_number] [varchar](50) NULL,
	[phone_number] [varchar](50) NULL,
	[refund_bank_name] [varchar](200) NULL,
	[refund_bank_card_no] [varchar](50) NULL,
	[refund_bank_open_name] [varchar](200) NULL,
	[refund_bank_city] [varchar](50) NULL,
	[refund_amount] [numeric](14, 2) NULL,
	[public_agent_name] [varchar](50) NULL,
	[public_agent_phone_number] [varchar](50) NULL,
	[public_agent_relation] [varchar](50) NULL,
	[public_agent_relation_id] [varchar](20) NULL,
	[public_agent_refund_bank_name] [varchar](200) NULL,
	[public_agent_refund_bank_card_no] [varchar](50) NULL,
	[public_agent_refund_bank_open_name] [varchar](200) NULL,
	[public_agent_refund_bank_city] [varchar](50) NULL,
	[audit_user_id] [varchar](50) NULL,
	[audit_user_name] [varchar](50) NULL,
	[audit_result] [varchar](50) NULL,
	[audit_date] [datetime] NULL,
	[refund_type_name] [varchar](10) NULL,
	[refund_type_id] [varchar](20) NULL,
	[audit_comment] [varchar](300) NULL,
	[rel_id] [nvarchar](36) NULL,
	[bank_card_holder] [varchar](50) NULL,
	[refund_balance] [numeric](14, 2) NULL,
	[refund_balance_sn] [varchar](32) NULL,
	[acct_id] [nvarchar](50) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[lzfy_refund_master] ADD  CONSTRAINT [DF_lzfy_refund_master_input_date]  DEFAULT (getdate()) FOR [input_date]
GO

ALTER TABLE [dbo].[lzfy_refund_master] ADD  CONSTRAINT [DF_lzfy_refund_master_aduit_result]  DEFAULT ((0)) FOR [audit_result]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据录入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'input_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'患者ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'patient_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'患者名字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'pat_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'患者身份证号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'id_number'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'患者手机号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'phone_number'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款银行名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_bank_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款银行卡号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_bank_card_no'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户行名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_bank_open_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户行所在城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_bank_city'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_amount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人名字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_phone_number'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人与退款人关系 关联lzfy_refund_dict.item_name,其中dicit_id=4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_relation'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人与退款人关系 关联lzfy_refund_dict.item_value,其中dicit_id=4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_relation_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人退款银行名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_refund_bank_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人退款银行卡号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_refund_bank_card_no'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人开户行名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_refund_bank_open_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代办人开户行所在城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'public_agent_refund_bank_city'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核人ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'audit_user_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核人名字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'audit_user_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核结果-审核成功 审核失败' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'audit_result'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'audit_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款类型名称关联lzfy_refund_dict.item_name,其中dicit_id=2  本人退款、代办人退款' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_type_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款类型关联lzfy_refund_dict.item_value,其中dicit_id=2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_type_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核意见，由审核人填写，如审核不通过应详细描述原因！' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'audit_comment'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'银行卡开户人名字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'bank_card_holder'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'实际退款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'refund_balance'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结算ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_master', @level2type=N'COLUMN',@level2name=N'acct_id'
GO


/****** Object:  Table [dbo].[lzfy_refund_dict]    Script Date: 2025/6/19 12:37:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lzfy_refund_dict](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[input_date] [datetime] NULL,
	[dict_id] [int] NULL,
	[dict_name] [varchar](50) NULL,
	[item_name] [varchar](50) NULL,
	[item_value] [varchar](10) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[lzfy_refund_dict] ADD  CONSTRAINT [DF_lzfy_refund_dict_input_date]  DEFAULT (getdate()) FOR [input_date]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID,自增' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_dict', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据录入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_dict', @level2type=N'COLUMN',@level2name=N'input_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_dict', @level2type=N'COLUMN',@level2name=N'dict_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_dict', @level2type=N'COLUMN',@level2name=N'dict_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字典明细名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_dict', @level2type=N'COLUMN',@level2name=N'item_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_dict', @level2type=N'COLUMN',@level2name=N'item_value'
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lzfy_refund_attach](
	[id] [int] NOT NULL,
	[input_date] [datetime] NULL,
	[attach_name] [varchar](20) NULL,
	[attach_id] [varchar](20) NULL,
	[attach_files] [varbinary](max) NULL,
	[rel_id] [nvarchar](36) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[lzfy_refund_attach] ADD  CONSTRAINT [DF_lzfy_refund_attach_input_date]  DEFAULT (getdate()) FOR [input_date]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_attach', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'录入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_attach', @level2type=N'COLUMN',@level2name=N'input_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件名称关联lzfy_refund_dict.item_name,其中dicit_id=1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_attach', @level2type=N'COLUMN',@level2name=N'attach_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件名称关联lzfy_refund_dict.item_value,其中dicit_id=1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_attach', @level2type=N'COLUMN',@level2name=N'attach_id'
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[users](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](50) NOT NULL,
	[password_hash] [nvarchar](255) NOT NULL,
	[email] [nvarchar](100) NULL,
	[full_name] [nvarchar](100) NULL,
	[role] [nvarchar](20) NOT NULL,
	[is_active] [bit] NOT NULL,
	[created_at] [datetime2](7) NOT NULL,
	[updated_at] [datetime2](7) NOT NULL,
	[last_login_at] [datetime2](7) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[username] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT ('User') FOR [role]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT ((1)) FOR [is_active]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT (getdate()) FOR [created_at]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT (getdate()) FOR [updated_at]
GO


/****** Object:  Table [dbo].[users]    Script Date: 2025/6/24 19:49:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[users](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](50) NOT NULL,
	[password_hash] [nvarchar](255) NOT NULL,
	[email] [nvarchar](100) NULL,
	[full_name] [nvarchar](100) NULL,
	[role] [nvarchar](20) NOT NULL,
	[is_active] [bit] NOT NULL,
	[created_at] [datetime2](7) NOT NULL,
	[updated_at] [datetime2](7) NOT NULL,
	[last_login_at] [datetime2](7) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[username] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT ('User') FOR [role]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT ((1)) FOR [is_active]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT (getdate()) FOR [created_at]
GO

ALTER TABLE [dbo].[users] ADD  DEFAULT (getdate()) FOR [updated_at]
GO

/****** Object:  Table [dbo].[lzfy_refund_verify_info]    Script Date: 2025/6/28 11:25:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lzfy_refund_verify_info](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[input_date] [datetime] NULL,
	[patient_id] [varchar](50) NULL,
	[verify_code] [varchar](50) NULL,
	[qr_code] [varchar](50) NULL,
	[refund_balance] [numeric](14, 2) NULL,
	[user_id] [varchar](50) NULL,
	[user_name] [varchar](50) NULL,
	[pat_name] [varchar](50) NULL,
	[id_number] [varchar](50) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[lzfy_refund_verify_info] ADD  CONSTRAINT [DF_lzfy_refund_verify_info_input_date]  DEFAULT (getdate()) FOR [input_date]
GO

/****** Object:  Table [dbo].[lzfy_refund_acct]    Script Date: 2025/7/1 21:30:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lzfy_refund_acct](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[input_date] [datetime] NULL,
	[username] [nvarchar](50) NULL,
	[full_name] [nvarchar](100) NULL,
	[acct_id] [nvarchar](50) NULL,
	[refund_balance_sum] [numeric](14, 2) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[lzfy_refund_acct] ADD  CONSTRAINT [DF_lzfy_refund_acct_input_date]  DEFAULT (getdate()) FOR [input_date]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_acct', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据录入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_acct', @level2type=N'COLUMN',@level2name=N'input_date'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_acct', @level2type=N'COLUMN',@level2name=N'username'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_acct', @level2type=N'COLUMN',@level2name=N'full_name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结算ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_acct', @level2type=N'COLUMN',@level2name=N'acct_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本单总金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_refund_acct', @level2type=N'COLUMN',@level2name=N'refund_balance_sum'
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[lzfy_call_log](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[input_date] [datetime] NULL,
	[username] [varchar](50) NULL,
	[fullname] [varchar](50) NULL,
	[call_phone] [varchar](50) NULL,
	[user_phone] [varchar](50) NULL,
	[send_msg] [smallint] NULL,
 CONSTRAINT [PK_lzfy_call_log] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[lzfy_call_log] ADD  CONSTRAINT [DF_lzfy_call_log_input_date]  DEFAULT (getdate()) FOR [input_date]
GO

ALTER TABLE [dbo].[lzfy_call_log] ADD  CONSTRAINT [DF_lzfy_call_log_send_msg]  DEFAULT ((0)) FOR [send_msg]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_call_log', @level2type=N'COLUMN',@level2name=N'username'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户真实名字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_call_log', @level2type=N'COLUMN',@level2name=N'fullname'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'患者电话号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_call_log', @level2type=N'COLUMN',@level2name=N'call_phone'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户电话号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_call_log', @level2type=N'COLUMN',@level2name=N'user_phone'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否发送短信 0 未发送 1发送' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'lzfy_call_log', @level2type=N'COLUMN',@level2name=N'send_msg'
GO
